{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["VBA School Closing Times","City-wise closing times"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"VBA School Closing Times","index":0,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[20,1,20,2],[21,1,21,2],[1,1,1,10]]}
[]
[null,"VBA Class Registration Closing Times Around the World"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Time in \"&valDispZone","v":"Time in ET - New York etc."},null,{"$f":"currentTime","v":"2011-09-16T10:53:21.510"}," ",null,{"$f":"IFERROR(DAY(D22-D21),0)","v":0},{"$f":"IFERROR(HOUR(D22-D21),0)","v":16},{"$f":"IFERROR(MINUTE(D22-D21),0)","v":5},{"$f":"IFERROR(SECOND(D22-D21),0)","v":38}]
[null,"Closing Time",null,{"$f":"closingTime","v":"2011-09-17T02:59:00"},null,"Time left","Days","Hours","Minutes","Seconds"]
[]
[]
[]
[]
[]
[null,"spot3"]
[null,1]
[null,"City",{"$f":"INDEX('City-wise closing times'!D$2:D$64,'VBA School Closing Times'!$B$29)","v":"Select a city"},{"$f":"IF(valSelCity>1,C30,INDEX($B$35:$B$43,SUBSTITUTE(valHotSpot,\"spot\",\"\")+0))","v":"ET - New York etc."}]
[null,"Time",{"$f":"INDEX('City-wise closing times'!C$2:C$64,'VBA School Closing Times'!$B$29)","v":"Time"},{"$f":"IF(LEFT(C31,3)=\"Sat\",DATE(2011,9,17),DATE(2011,9,16))+TIMEVALUE(MID(C31,FIND(\" \",C31)+1,99))","v":{"$error":"#VALUE!"}}]
[null,false,{"$f":"IF($D$32>0,\"You still have time\",\"Oops, time up!!!\")","v":"You still have time"},{"$f":"SUM(rngTimeLeft)","v":59}]
[]
[null,"Timezone - Areas","Registration Closes at"]
[null,"PT, PST - Seattle, LA, SF etc.","2011-09-16T23:59:00"]
[null,"CT - Chicago etc.",{"$f":"C35+2/24","v":"2011-09-17T01:59:00"}]
[null,"ET - New York etc.",{"$f":"C35+3/24","v":"2011-09-17T02:59:00"}]
[null,"GMT - London",{"$f":"C35+8/24","v":"2011-09-17T07:59:00"}]
[null,"CET - France, Sweden etc.",{"$f":"C38+1/24","v":"2011-09-17T08:59:00"}]
[null,"EET - Greece, Finland etc.",{"$f":"C39+1/24","v":"2011-09-17T09:59:00"}]
[null,"IST - India",{"$f":"C38+4.5/24","v":"2011-09-17T12:29:00"}]
[null,"Japan - Tokyo",{"$f":"C38+8/24","v":"2011-09-17T15:59:00"}]
[null,"Australia - Sydney",{"$f":"C38+9/24","v":"2011-09-17T16:59:00"}]

{"sheet":"City-wise closing times","index":1,"n_rows":64,"n_cols":4,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[null,"City","Time","Select a city"]
[null,"Adelaide","Sat 16:29","Adelaide"]
[null,"Algiers","Sat 07:59","Algiers"]
[null,"Amsterdam *","Sat 08:59","Amsterdam"]
[null,"Ankara *","Sat 09:59","Ankara"]
[null,"Athens *","Sat 09:59","Athens"]
[null,"Auckland","Sat 18:59","Auckland"]
[null,"Bangkok","Sat 13:59","Bangkok"]
[null,"Barcelona *","Sat 08:59","Barcelona"]
[null,"Beijing","Sat 14:59","Beijing"]
[null,"Belgrade *","Sat 08:59","Belgrade"]
[null,"Berlin *","Sat 08:59","Berlin"]
[null,"Brisbane","Sat 16:59","Brisbane"]
[null,"Brussels *","Sat 08:59","Brussels"]
[null,"Bucharest *","Sat 09:59","Bucharest"]
[null,"Budapest *","Sat 08:59","Budapest"]
[null,"Buenos Aires","Sat 03:59","Buenos Aires"]
[null,"Cairo","Sat 08:59","Cairo"]
[null,"Cape Town","Sat 08:59","Cape Town"]
[null,"Caracas","Sat 02:29","Caracas"]
[null,"Copenhagen *","Sat 08:59","Copenhagen"]
[null,"Darwin","Sat 16:29","Darwin"]
[null,"Dublin *","Sat 07:59","Dublin"]
[null,"Frankfurt *","Sat 08:59","Frankfurt"]
[null,"Guatemala","Sat 00:59","Guatemala"]
[null,"Havana *","Sat 02:59","Havana"]
[null,"Helsinki *","Sat 09:59","Helsinki"]
[null,"Hong Kong","Sat 14:59","Hong Kong"]
[null,"Jakarta","Sat 13:59","Jakarta"]
[null,"Johannesburg","Sat 08:59","Johannesburg"]
[null,"Kingston","Sat 01:59","Kingston"]
[null,"Kinshasa","Sat 07:59","Kinshasa"]
[null,"Kuala Lumpur","Sat 14:59","Kuala Lumpur"]
[null,"La Paz","Sat 02:59","La Paz"]
[null,"Lima","Sat 01:59","Lima"]
[null,"Lisbon *","Sat 07:59","Lisbon"]
[null,"London *","Sat 07:59","London"]
[null,"Madrid *","Sat 08:59","Madrid"]
[null,"Manila","Sat 14:59","Manila"]
[null,"Melbourne","Sat 16:59","Melbourne"]
[null,"Mexico City *","Sat 01:59","Mexico City"]
[null,"Montevideo","Sat 03:59","Montevideo"]
[null,"Moscow *","Sat 10:59","Moscow"]
[null,"Nairobi","Sat 09:59","Nairobi"]
[null,"New Delhi","Sat 12:29","New Delhi"]
[null,"Oslo *","Sat 08:59","Oslo"]
[null,"Paris *","Sat 08:59","Paris"]
[null,"Perth","Sat 14:59","Perth"]
[null,"Prague *","Sat 08:59","Prague"]
[null,"Rio de Janeiro","Sat 03:59","Rio de Janeiro"]
[null,"Rome *","Sat 08:59","Rome"]
[null,"Santiago","Sat 03:59","Santiago"]
[null,"São Paulo","Sat 03:59","São Paulo"]
[null,"Shanghai","Sat 14:59","Shanghai"]
[null,"Singapore","Sat 14:59","Singapore"]
[null,"Sofia *","Sat 09:59","Sofia"]
[null,"Stockholm *","Sat 08:59","Stockholm"]
[null,"Sydney","Sat 16:59","Sydney"]
[null,"Tokyo","Sat 15:59","Tokyo"]
[null,"Vienna *","Sat 08:59","Vienna"]
[null,"Vladivostok *","Sat 17:59","Vladivostok"]
[null,"Warsaw *","Sat 08:59","Warsaw"]
[null,"Zürich *","Sat 08:59","Zürich"]